using System; 
using System.Text; 
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration; 
using System.Xml; 
using System.Xml.Serialization;
using SubSonic; 
using SubSonic.Utilities;

namespace Zoo.DAL{
    public partial class SPs{
        
        /// <summary>
        /// Creates an object wrapper for the SP_GetUserID Procedure
        /// </summary>
        public static StoredProcedure SpGetUserID(string NickName, string Password)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("SP_GetUserID" , DataService.GetInstance("ZooDB"));
        	
            sp.Command.AddParameter("@NickName", NickName,DbType.String);
        	    
            sp.Command.AddParameter("@Password", Password,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the SP_GetDictionary Procedure
        /// </summary>
        public static StoredProcedure SpGetDictionary()
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("SP_GetDictionary" , DataService.GetInstance("ZooDB"));
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the SP_GetNewUsers Procedure
        /// </summary>
        public static StoredProcedure SpGetNewUsers(string language)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("SP_GetNewUsers" , DataService.GetInstance("ZooDB"));
        	
            sp.Command.AddParameter("@language", language,DbType.String);
        	    
            return sp;
        }

        
    }

    
}

